** generate Table 1: Summary Statistics **
use clean.dta, clear
sum nfippolicies ChangeInPolicies nfipclaims nfip_realvalue sba_realvalue drf_realvalue damages_realvalue floods



**** RESULTS ****
** generate Table 2a - results for ChangeInPolicies as Dependent Variable **
reg ChangeInPolicies laglndamages lagfloods yr katrina, robust
reg ChangeInPolicies laglndamages lagfloods yr katrina fira94 fira94trend, robust
reg ChangeInPolicies laglndamages lagfloods yr katrina fira04 fira04trend, robust
reg ChangeInPolicies laglndamages lagfloods yr katrina grant06 grant06trend, robust
** generate Table 2b - results for lnclaims as Dependent Variable **
newey lnclaims lnsba lndrf lndamages floods yr katrina, lag(2) force
newey lnclaims lnsba lndrf lndamages floods yr katrina fira94 fira94trend, lag(2) force
newey lnclaims lnsba lndrf lndamages floods yr katrina fira94 fira94trend fira04 fira04trend, lag(2) force
newey lnclaims lnsba lndrf lndamages floods yr katrina fira94 fira94trend grant06 grant06trend, lag(2) force
** generate Table 2c - results for lnclaimvalue as Dependent Variable **
newey lnclaimvalue lnsba lndrf lndamages floods yr katrina, lag(2) force
newey lnclaimvalue lnsba lndrf lndamages floods yr katrina fira94 fira94trend, lag(2) force
newey lnclaimvalue lnsba lndrf lndamages floods yr katrina fira04 fira04trend, lag(2) force
newey lnclaimvalue lnsba lndrf lndamages floods yr katrina grant06 grant06trend, lag(2) force


** generate histograms - reported in appendix Figure A1 - A13**
hist nfippolicies, freq normal
hist ChangeInPolicies, freq normal
hist nfip_realvalue, freq normal
hist nfipclaims, freq normal
hist lnclaims, freq normal
hist nfip_realvalue, freq normal
hist lnclaimvalue, freq normal
hist sba_realvalue, freq normal
hist lnsba, freq normal
hist drf_realvalue, freq normal
hist lndrf, freq normal
hist damages_realvalue, freq normal
hist lndamages, freq normal
hist floods, freq normal

** Dickey-Fuller test for unit root *** generate Table A1 ***
dfuller nfippolicies, trend
dfuller ChangeInPolicies, trend
dfuller nfipclaims, trend
dfuller nfip_realvalue, trend
dfuller sba_realvalue, trend
dfuller drf_realvalue, trend
dfuller damages_realvalue, trend
dfuller floods, trend

** Bruesch-Godfrey test for serial correlation *** generate Table A2 *** 
reg ChangeInPolicies sba_realvalue drf_realvalue damages_realvalue floods yr
estat bgodfrey, lag (1)
estat bgodfrey, lag (5)
estat bgodfrey, lag (10)
reg nfipclaims sba_realvalue drf_realvalue damages_realvalue floods yr 
estat bgodfrey, lag (1)
estat bgodfrey, lag (5)
estat bgodfrey, lag (10)
reg nfip_realvalue sba_realvalue drf_realvalue damages_realvalue floods yr 
estat bgodfrey, lag (1)
estat bgodfrey, lag (5)
estat bgodfrey, lag (10)
